Why Is the Today() Formula Returning the Wrong Value During Daily Formula Recalculation?

Currently, Daily Formula Recalculation is executed based on the UTC+0 time zone, which may lead to results that differ from the time zone set in the user account.

Example:

If your account is set to the "UTC+8" time zone and the daily formula recalculation time is "01:00", the system will still execute the recalculation based on "UTC+0". At "UTC+8 01:00", it is only "17:00" of the previous day in "UTC+0", so the TODAY() function will return the "previous day's date", making the result appear one day behind.

Solution:

Replace TODAY() with TODAYTZ() in your formulas.

TODAYTZ() returns the correct local date based on your company’s time zone setting, ensuring accurate results during daily formula recalculation.